DisbursementApprovalRule

EntityType | Independent
Logical Entity Name | DisbursementApprovalRule
Default Table Name | FaApproveDisbCriteria
Logical Only | NO
Owner | dbo
Definition |
Note |

DisbursementApprovalRule Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
Code |  | CHAR(10) | NO |
Name |  | VARCHAR(40) | NO |
IsMinPctAttendanceRequired |  | BIT | NO |
MinPctAttendance |  | NUMERIC(8, 2) | NO |
IsMinHoursAttendanceRequired |  | BIT | NO |
MinHoursAttended |  | NUMERIC(9, 2) | NO |
IsMinNumericAvgRequired |  | BIT | NO |
MinNumericAverage |  | NUMERIC(11, 6) | NO |
IsMinCumulativeGpaRequired |  | BIT | NO |
MinCumulativeGPA |  | NUMERIC(18, 6) | NO |
IsMinHoursCreditsScheduledRequired |  | BIT | NO |
MinClockHoursScheduled |  | NUMERIC(18, 2) | NO |
MinCreditHoursScheduled |  | NUMERIC(18, 2) | NO |
IsMinHoursCreditsCompletedRequired |  | BIT | NO |
MinClockHoursCompleted |  | NUMERIC(18, 2) | NO |
MinCreditHoursCompleted |  | NUMERIC(18, 2) | NO |
IsFaCreditsHoursEarnedAttemptedRequired |  | BIT | NO |
FaCreditsHoursEarnedAttemptedFlag |  | CHAR(1) | NO |
IsMaxDaysAfterStudentLdaRequired |  | BIT | NO |
MaxDaysAfterStudentLda |  | INTEGER | NO |
IsMissingDocumentsChecked |  | BIT | NO |
IsStudentSchoolStatusChecked |  | BIT | NO |
IsMeetingSapRequired |  | BIT | NO |
RequiredStudentSap |  | CHAR(8) | NO |
IsIsirOnFileRequired |  | BIT | NO |
IsAcceptedOriginationRequired |  | BIT | NO |
IsVerificationStatusChecked |  | BIT | NO |
VerificationStatus |  | VARCHAR(25) | NO |
IsMaxDisbursementAmountDifferenceChecked |  | BIT | NO |
MaxDisbursementAmountDifference |  | MONEY(19, 4) | NO |
IsMaxDaysPriorTermStartDateChecked |  | BIT | NO |
MaxDaysPriorTermStartDate |  | INTEGER | NO |
IsFirstTimeBorrowerRule |  | BIT | NO |
IsMaxDaysFromLoanPeriodEndDateChecked |  | BIT | NO |
MaxDaysFromLoanPeriodEndDate |  | INTEGER | NO |
IsActive |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
IsEnrollmentToPackageStatusRequired |  | BIT | NO |
IsEvaluationByTerm |  | BIT | NO |
IsAttendanceAllCoursesEvaluated |  | BIT | NO |
IsDocumentCompletionDateConfirmed |  | BIT | NO |
IsOriginationCertifiedBeforeLda |  | BIT | NO |
IsResidencyStateChecked |  | BIT | NO |
ResidencyState |  | CHAR(2) | YES |
IsStateResidentSinceChecked |  | BIT | NO |
ResidencyStateYears |  | SMALLINT | YES |
BachelorsDegree |  | CHAR(1) | NO |
GraduateLevelProgram |  | CHAR(1) | NO |
IsEntranceInterviewRequired |  | BIT | NO |
MinEnrollmentStatusId |  | INTEGER | YES |
IsMinPaymentPeriodHoursAttendedRequired |  | BIT | NO |
MinPaymentPeriodHoursAttended |  | NUMERIC(9, 2) | NO |

DisbursementApprovalRule Keys

Key Name | Key Type | Keys
FaApproveDisbCriteria_FaApproveDisbCriteriaID_U_C_IDX | PrimaryKey | Id
FaApproveDisbCriteria_Code_U_N_IDX | Unique Constraint | Code
FaApproveDisbCriteria_UserId_N_N_IDX | Inversion Entry | LastModifiedUserId

DisbursementApprovalRule Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
EnrollmentStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | MinEnrollmentStatusId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
DisbursementApprovalRuleSchoolStatusList | Identifying | One To Zero or More |  |  |  |  | NO
DisbursementApprovalRuleMultipleDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
DisbursementApprovalRuleDocumentType | Identifying | One To Zero or More |  |  |  |  | NO
DisbursementApprovalRuleCampusFundSource | Non-Identifying | One To Zero or More |  |  |  |  | NO

DisbursementApprovalRule Check Constraints

Check Constraint Name | CheckConstraint
Chk_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched | ([MinHoursCreditsSchedFlag] = 1 and ([MinHoursSched] > 0 or [MinCreditsSched] > 0) or [MinHoursCreditsSchedFlag] = 0 and ([MinHoursSched] = 0 and [MinCreditsSched] = 0))
Chk_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp | ([MinHoursCreditsCompFlag] = 1 and ([MinHoursComp] > 0 or [MinCreditsComp] > 0) or [MinHoursCreditsCompFlag] = 0 and ([MinHoursComp] = 0 and [MinCreditsComp] = 0))
Chk_FaApproveDisbCriteria_MinNumAvgFlag_MinNumAvg | ([MinNumAvgFlag] = 1 and [MinNumAvg] > 0 or [MinNumAvgFlag] = 0 and [MinNumAvg] = 0)
Chk_FaApproveDisbCriteria_MinHoursAttFlag_MinHoursAtt | ([MinHoursAttFlag] = 1 and [MinHoursAtt] > 0 or [MinHoursAttFlag] = 0 and [MinHoursAtt] = 0)
Chk_FaApproveDisbCriteria_MinPctAttFlag_MinPctAtt | ([MinPctAttFlag] = 1 and [MinPctAtt] > 0 or [MinPctAttFlag] = 0 and [MinPctAtt] = 0)
Chk_FaApproveDisbCriteria_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA | ([MaxDaysAfterStudLDAFlag] = 1 and [MaxDaysAfterStudLDA] >= 0 or [MaxDaysAfterStudLDAFlag] = 0 and [MaxDaysAfterStudLDAFlag] = 0)
Chk_FaApproveDisbCriteria_MinCumulativeGPAFlag_MinCumulativeGPA | ([MinCumulativeGPAFlag] = 1 and [MinCumulativeGPA] > 0 or [MinCumulativeGPAFlag] = 0 and [MinCumulativeGPA] = 0)
Chk_FaApproveDisbCriteria_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate | ([MaxDaysFromLoanEndDateFlag] = 1 and [MaxDaysFromLoanEndDate] >= 0 or [MaxDaysFromLoanEndDateFlag] = 0 and [MaxDaysFromLoanEndDate] = 0)
Chk_FaApproveDisbCriteria_MaxDiffDisbAmtFlag_MaxDiffDisbAmt | ([MaxDiffDisbAmtFlag] = 1 and [MaxDiffDisbAmt] >= 0 or [MaxDiffDisbAmtFlag] = 0 and [MaxDiffDisbAmt] = 0)

DisbursementApprovalRule Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DisbursementApprovalRule | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaApproveDisbCriteria | NO |  |  |

DisbursementApprovalRule Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

DisbursementApprovalRule Data Movement Rules

Name | Type | Rule Text/Value